﻿CREATE VIEW [dbo].[FacebookUserStorageInfos] AS
SELECT i.[InstanceId]
      ,fb.[FacebookUserId]
      ,i.[Submission]
      ,i.[AppFoldersSize]
      ,i.[BackupSize]
      ,i.[OperatingSystemSize]
      ,i.[SharedFoldersSize]
      ,i.[SharedFoldersDupSize]
      ,i.[StorageFreeSpace]
      ,i.[StorageSize]
      ,i.[StorageUsedSpace]
  FROM [UserStorageInfosLatest] i
  INNER JOIN [FacebookInstanceMapping] fb
  ON i.InstanceId=fb.InstanceId
